UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PcferwDj++xkXbtmy4JvW/zR3Nvc+Aggp3yvWuTV/x4='
WHERE
key_id = 'c1195d5e0b592b89615442220da3bff44e1e380b4305eee91e273d334cc0ae59'
AND (
token = 'PcferwDj++xkXbtmy4JvW/zR3Nvc+Aggp3yvWuTV/x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)