UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JlZR2qKzwZEQdP4D9j53dziBShLYwkftTUjR5tL+xvw='
WHERE
key_id = 'afd5466cd265d4e80cced59a032aa46f6b6fa613c8e23e365b66948ed4943df0'
AND (
token = 'JlZR2qKzwZEQdP4D9j53dziBShLYwkftTUjR5tL+xvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)