UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPLYjHXgOnSoxfckh73bddsi5gnJJPbDX/Yzk2uA3Ww='
WHERE
key_id = '6197420a14b98347d025a432349c7818f554c24c0b04c998807b1377efda1802'
AND (
token = 'XPLYjHXgOnSoxfckh73bddsi5gnJJPbDX/Yzk2uA3Ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)