UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '97avAewoLFg3Y6JKrooZVqyvKZIW8ZhtER4JIijXaAk='
WHERE
key_id = '793d87f8a6d674a2ff05b73a9ca01fa96bf1f46f4ad63a5ff8b3a7e07642c877'
AND (
token = '97avAewoLFg3Y6JKrooZVqyvKZIW8ZhtER4JIijXaAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)