UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CIM78Y5qt0W/GUJjVIG62S/htUMOhihqMOsmPSr8EpE='
WHERE
key_id = '3d7b5e4c68962c6d0831dc198b700b842326fcc02afa4c56f6ec83e2302fc530'
AND (
token = 'CIM78Y5qt0W/GUJjVIG62S/htUMOhihqMOsmPSr8EpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)