UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+O+B2QHaKd27P4ITM+YHaW0Q+Ys3zwb+nYVYAGAfUnk=' 
WHERE 
  key_id = '9c77bc502302bfd08859a405403472e2d3e4d3e0f64a075ed212c50aaf4ec930' 
  AND (
    token = '+O+B2QHaKd27P4ITM+YHaW0Q+Ys3zwb+nYVYAGAfUnk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026