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