UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aBGtZgkdAKg9RGxHYh5OwJ6MZuAhdxDopDZ7L23qv9k='
WHERE
key_id = '50caa501a1ad8a19bbf5f76d5beb50e24a2f1cfd47831928c161797beac775af'
AND (
token = 'aBGtZgkdAKg9RGxHYh5OwJ6MZuAhdxDopDZ7L23qv9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)