UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zgObxuHbHBvlHoRpeff69zfEprC1SzXti1JiVLASZw='
WHERE
key_id = 'aa55f5608d5e12d67a2ad0209f9870bb141bd5edc112db576a9fee39600ead00'
AND (
token = '8zgObxuHbHBvlHoRpeff69zfEprC1SzXti1JiVLASZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)