UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5usYs0Nr7ua4KO6YSsZvZUeVYmXac5v1rjYZlNDRvMc=' 
WHERE 
  key_id = '5a6f6bf3c259cdae1ba72669265a770d6e5d17c67b2ed085446ee2a5de28d11e' 
  AND (
    token = '5usYs0Nr7ua4KO6YSsZvZUeVYmXac5v1rjYZlNDRvMc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034