UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TqbRY2X52Nfu66t8XSx8Bxhl0lsV5jiXLU10Tpc8nCA='
WHERE
key_id = '1f33a01866710242d2c5a6df67e34539752614b5cd027444c8044b655ce9b324'
AND (
token = 'TqbRY2X52Nfu66t8XSx8Bxhl0lsV5jiXLU10Tpc8nCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)