UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnRIqRYqhCcbfz1qkxMIrenqg1Q2NwBcL4lkaBih8zw='
WHERE
key_id = 'e00bcfc4f249a4db5fb6c016259bb2fc8644bde29733550987df25933c37610e'
AND (
token = 'KnRIqRYqhCcbfz1qkxMIrenqg1Q2NwBcL4lkaBih8zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)