UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQ9iyKaaO8a2WVHis1LKWyG0GyiNxCBCwBRi831CLo0='
WHERE
key_id = '2c625bd37e19004180df4edf52845a742d749cafb3a53f3500798b147d1898b8'
AND (
token = 'ZQ9iyKaaO8a2WVHis1LKWyG0GyiNxCBCwBRi831CLo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)