UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QR2ARtJKhzgVkQXGHuiT30pdxGmQ6da+pItNitgkoVo='
WHERE
key_id = '507bd33ad7670363d6df2726e143b83642814a6eb34010ef078f3ec9092f4797'
AND (
token = 'QR2ARtJKhzgVkQXGHuiT30pdxGmQ6da+pItNitgkoVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)