UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sy6Iprj1n0Og7rSNqzy7jFMprAt7BN0AY4Pg8NuqNlM='
WHERE
key_id = 'e4e35863ad94a6e2b8fa773854d8c6e2c4e646e2f7d927f9e7325496a0975e38'
AND (
token = 'sy6Iprj1n0Og7rSNqzy7jFMprAt7BN0AY4Pg8NuqNlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)