UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qYd+0X/ws5OBdPXsAuQW5p+bbiEIHEwH9C7IQKH7I5I='
WHERE
key_id = 'c5b1bc224d82c98db121ad3c23929aabba1e127b1567f3df1aa5dbead037e152'
AND (
token = 'qYd+0X/ws5OBdPXsAuQW5p+bbiEIHEwH9C7IQKH7I5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)