UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3F9LdohmpEJwC9Ooe5GJUZySziumQZBgbNT73MiNOus='
WHERE
key_id = 'a57f2767c9d5e6d1355424f57c1a6487a0beb4561d1acb78fefc06260fe8a05e'
AND (
token = '3F9LdohmpEJwC9Ooe5GJUZySziumQZBgbNT73MiNOus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)