UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NavOP8p7G9iK9VpG4cspGzouo4d3NJJ9mZmjDStmaNY='
WHERE
key_id = '707a1c41d5770391d5cdad590536be80d7e895094c10f674c5cbbc7c2d532e00'
AND (
token = 'NavOP8p7G9iK9VpG4cspGzouo4d3NJJ9mZmjDStmaNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)