UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '79aJJT+1983QqfWKSLvXWe3J1NOHvhtwdXODzc7mtwc='
WHERE
key_id = '3978025b4672563e3c438f10733e580c4dd674c68b595ea9efda27600ed9bba6'
AND (
token = '79aJJT+1983QqfWKSLvXWe3J1NOHvhtwdXODzc7mtwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)