UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eZ2wvmUsIh35f6x9GoRXY8y/l0Wk29Vw7xYnEyrPB3g=' 
WHERE 
  key_id = '1134dbada7a87fab2ac11cf88ce7d4fd81e6b1ab380fc9d53fccb83ff5673b00' 
  AND (
    token = 'eZ2wvmUsIh35f6x9GoRXY8y/l0Wk29Vw7xYnEyrPB3g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032