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