UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FIfTOOlWWgZvAU04kj4JPlVg929BwdoVXDcSlzdHc4k='
WHERE
key_id = '8e3e638dc95d44ef475cdab197b997511436b8d6edbc574febafcd95f9aa6245'
AND (
token = 'FIfTOOlWWgZvAU04kj4JPlVg929BwdoVXDcSlzdHc4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)