UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0eRu1K/yy0+pyNQRu1z5Y4qSm2nX2S7OwM0+nVRIJaA=' 
WHERE 
  key_id = 'cb6e5600a23132455795101a166ab56b1f650a8aa79c44e6b9c1655ec512f1ed' 
  AND (
    token = '0eRu1K/yy0+pyNQRu1z5Y4qSm2nX2S7OwM0+nVRIJaA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017