UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsN6mgHPjyWw2xVTAFROaAU/yAl4KnSecKiIqYUlUSs='
WHERE
key_id = '8245d03ca74f9cbe3798623b2c6175d8b5e08bb92037b41902b9e6b3597f8947'
AND (
token = 'BsN6mgHPjyWw2xVTAFROaAU/yAl4KnSecKiIqYUlUSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)