UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xRq1+Dc/1I52WVCQrPwGAAtcSHP6y6nVTpVzg+G5gl8=' 
WHERE 
  key_id = '74619f37bb09d7842047b69db4d9c240cfe8936636bee7fa1c62cf908d8b4801' 
  AND (
    token = 'xRq1+Dc/1I52WVCQrPwGAAtcSHP6y6nVTpVzg+G5gl8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042