UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M54iI69AEiJzoIM03pJY6833tD0IU04IEG1ILuW3SHo='
WHERE
key_id = '27d3e3b3471ce64c39230315b04f4ed03df9a77a96ccd67055087e9ffabed243'
AND (
token = 'M54iI69AEiJzoIM03pJY6833tD0IU04IEG1ILuW3SHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)