UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F849r3OSvV4lHupZT6La1aYgnQDburhkCL8kAeyZaBs='
WHERE
key_id = '304aedd5742ef3fdb389510f766e30a065c56f466bf9b2b2fa23d00f376aa731'
AND (
token = 'F849r3OSvV4lHupZT6La1aYgnQDburhkCL8kAeyZaBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)