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