UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rYmg5YCvGdedyHBZrcx8eKujy7xz+yL7J0LCza85eLE='
WHERE
key_id = '7d010e13c75c7d763ab9b5aa2a1fb78affad00cf537867d6f658333ad12717ff'
AND (
token = 'rYmg5YCvGdedyHBZrcx8eKujy7xz+yL7J0LCza85eLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)