UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9CSrjFaYzLKG9B57YJv63zCcsx61ThEG2PUYsFNR/Lw='
WHERE
key_id = '158dca5f54bef5d0a277b903f99e13cd2d34684058936ff99ee37db5a6df5138'
AND (
token = '9CSrjFaYzLKG9B57YJv63zCcsx61ThEG2PUYsFNR/Lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)