UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dCUkdtXvctmTwdCxiEjr/K6EQNjrKy2EWY3pKT4X+s='
WHERE
key_id = '4ee252f1e822bd3026049db1a1318391ac9ab811dce6e830e8bfef5b3065554c'
AND (
token = '8dCUkdtXvctmTwdCxiEjr/K6EQNjrKy2EWY3pKT4X+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)