UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'exTmGZC1WEX6tATM3XjoYInuNVbVjh4qpEFMEL7IKmY='
WHERE
key_id = '42a1b79cca4e4c44fd8ea89282b760eb439a71ca5bce94474cc5171ab25cc4b5'
AND (
token = 'exTmGZC1WEX6tATM3XjoYInuNVbVjh4qpEFMEL7IKmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)