UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LzjAs1yewnHn6OyT473Y3kXFpy2Pyuv9CarnW94RVKM='
WHERE
key_id = '23f7ca2ef153c3e630cc512412e687a0da760d48c0c3e3c040221927b7ba46d2'
AND (
token = 'LzjAs1yewnHn6OyT473Y3kXFpy2Pyuv9CarnW94RVKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)