UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zOKOe5nwQ3nyvOja3pPBpMGX/EUl4yO1m7zeF3ACq/U='
WHERE
key_id = '09309465b332435c42131a8c8654402f9d60ef90afec794c0e6326de191fdf52'
AND (
token = 'zOKOe5nwQ3nyvOja3pPBpMGX/EUl4yO1m7zeF3ACq/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)