UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9lpw8Tzh6Voc4BMmoJyAIcdesANXyjS9TL5Y7b9X6C8='
WHERE
key_id = '683cde9f1c90cafdb8c5587ff0111c0b563ac81718a894824d489e351e767dc3'
AND (
token = '9lpw8Tzh6Voc4BMmoJyAIcdesANXyjS9TL5Y7b9X6C8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)