UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6QS8CM6I1++5Dys5rQ4Ndt4y7gEaha7VwnfwZgKWC9k=' 
WHERE 
  key_id = 'b3b2b69c9a0975ba4c58a29eaaed498de3c14fc4d7a54b793f048f028abc4377' 
  AND (
    token = '6QS8CM6I1++5Dys5rQ4Ndt4y7gEaha7VwnfwZgKWC9k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028