UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E0eNvZlcZZsjP+SpvPIHvUmRjEA8oobZWfhmucgFWws='
WHERE
key_id = 'f5ec661c6aaf249d3fb6bd6beef2cd4bcb505b15260d319414432c73128dc307'
AND (
token = 'E0eNvZlcZZsjP+SpvPIHvUmRjEA8oobZWfhmucgFWws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)