UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ggG1QdtP14Efhzm7UFIZhMEUiotVSn2xlAzM9mi1uj8='
WHERE
key_id = '7ae1ecda82870748c0e4f1b11b56e1455ab80be5360fb0d6a56984b67a1a2fc0'
AND (
token = 'ggG1QdtP14Efhzm7UFIZhMEUiotVSn2xlAzM9mi1uj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)